Deportes
  1. Portada >
  2. Deportes

Descripción del perfil turístico "Deportes".

Otros perfiles turísticos

Peñiscola - Sede ElectrónicaTurismo Peñiscola
21 queries took 130 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';61612
2SELECT DISTINCT column_name AS name, character_maximum_length as longitud, numeric_precision as precision, numeric_precision_radix as base_precision, numeric_scale as decimales, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='etiquetas' ORDER BY ordinal_position774
3SELECT DISTINCT column_name AS name, character_maximum_length as longitud, numeric_precision as precision, numeric_precision_radix as base_precision, numeric_scale as decimales, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='archivos' ORDER BY ordinal_position12123
4SELECT DISTINCT column_name AS name, character_maximum_length as longitud, numeric_precision as precision, numeric_precision_radix as base_precision, numeric_scale as decimales, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='nodos' ORDER BY ordinal_position25253
5SELECT DISTINCT column_name AS name, character_maximum_length as longitud, numeric_precision as precision, numeric_precision_radix as base_precision, numeric_scale as decimales, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='textos' ORDER BY ordinal_position11113
6SELECT DISTINCT column_name AS name, character_maximum_length as longitud, numeric_precision as precision, numeric_precision_radix as base_precision, numeric_scale as decimales, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='imagenes' ORDER BY ordinal_position552
7SELECT DISTINCT column_name AS name, character_maximum_length as longitud, numeric_precision as precision, numeric_precision_radix as base_precision, numeric_scale as decimales, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='videos' ORDER BY ordinal_position11113
8SELECT DISTINCT column_name AS name, character_maximum_length as longitud, numeric_precision as precision, numeric_precision_radix as base_precision, numeric_scale as decimales, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='enlaces' ORDER BY ordinal_position772
9SELECT DISTINCT column_name AS name, character_maximum_length as longitud, numeric_precision as precision, numeric_precision_radix as base_precision, numeric_scale as decimales, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='configuraciones' ORDER BY ordinal_position16163
10SELECT "Configuracion"."id" AS "Configuracion__id", "Configuracion"."titulo_texto_id" AS "Configuracion__titulo_texto_id", "Configuracion"."descripcion_texto_id" AS "Configuracion__descripcion_texto_id", "Configuracion"."keywords_texto_id" AS "Configuracion__keywords_texto_id", "Configuracion"."email_remitente" AS "Configuracion__email_remitente", "Configuracion"."clave_google" AS "Configuracion__clave_google", "Configuracion"."noticias_portada" AS "Configuracion__noticias_portada", "Configuracion"."eventos_portada" AS "Configuracion__eventos_portada", "Configuracion"."descargas_portada" AS "Configuracion__descargas_portada", "Configuracion"."youtube_login" AS "Configuracion__youtube_login", "Configuracion"."youtube_password" AS "Configuracion__youtube_password", "Configuracion"."sms_para_enviar" AS "Configuracion__sms_para_enviar", "Configuracion"."clave_ga" AS "Configuracion__clave_ga", "Configuracion"."twitter_login" AS "Configuracion__twitter_login", "Configuracion"."twitter_password" AS "Configuracion__twitter_password", "Configuracion"."email_alertas" AS "Configuracion__email_alertas", "Titulo"."id" AS "Titulo__id", "Titulo"."texto_es" AS "Titulo__texto_es", "Titulo"."texto_en" AS "Titulo__texto_en", "Titulo"."texto_va" AS "Titulo__texto_va", "Titulo"."texto_de" AS "Titulo__texto_de", "Titulo"."texto_fr" AS "Titulo__texto_fr", "Titulo"."texto_pl" AS "Titulo__texto_pl", "Titulo"."texto_ru" AS "Titulo__texto_ru", "Titulo"."texto_pt" AS "Titulo__texto_pt", "Titulo"."texto_nl" AS "Titulo__texto_nl", "Titulo"."texto_it" AS "Titulo__texto_it", "Descripcion"."id" AS "Descripcion__id", "Descripcion"."texto_es" AS "Descripcion__texto_es", "Descripcion"."texto_en" AS "Descripcion__texto_en", "Descripcion"."texto_va" AS "Descripcion__texto_va", "Descripcion"."texto_de" AS "Descripcion__texto_de", "Descripcion"."texto_fr" AS "Descripcion__texto_fr", "Descripcion"."texto_pl" AS "Descripcion__texto_pl", "Descripcion"."texto_ru" AS "Descripcion__texto_ru", "Descripcion"."texto_pt" AS "Descripcion__texto_pt", "Descripcion"."texto_nl" AS "Descripcion__texto_nl", "Descripcion"."texto_it" AS "Descripcion__texto_it", "Keywords"."id" AS "Keywords__id", "Keywords"."texto_es" AS "Keywords__texto_es", "Keywords"."texto_en" AS "Keywords__texto_en", "Keywords"."texto_va" AS "Keywords__texto_va", "Keywords"."texto_de" AS "Keywords__texto_de", "Keywords"."texto_fr" AS "Keywords__texto_fr", "Keywords"."texto_pl" AS "Keywords__texto_pl", "Keywords"."texto_ru" AS "Keywords__texto_ru", "Keywords"."texto_pt" AS "Keywords__texto_pt", "Keywords"."texto_nl" AS "Keywords__texto_nl", "Keywords"."texto_it" AS "Keywords__texto_it" FROM "configuraciones" AS "Configuracion" LEFT JOIN "textos" AS "Titulo" ON "Configuracion"."titulo_texto_id" = "Titulo"."id" LEFT JOIN "textos" AS "Descripcion" ON "Configuracion"."descripcion_texto_id" = "Descripcion"."id" LEFT JOIN "textos" AS "Keywords" ON "Configuracion"."keywords_texto_id" = "Keywords"."id" WHERE 1 = 1 LIMIT 1111
11SELECT DISTINCT column_name AS name, character_maximum_length as longitud, numeric_precision as precision, numeric_precision_radix as base_precision, numeric_scale as decimales, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='eventos' ORDER BY ordinal_position28283
12SELECT DISTINCT column_name AS name, character_maximum_length as longitud, numeric_precision as precision, numeric_precision_radix as base_precision, numeric_scale as decimales, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='evento_categorias' ORDER BY ordinal_position222
13SELECT DISTINCT column_name AS name, character_maximum_length as longitud, numeric_precision as precision, numeric_precision_radix as base_precision, numeric_scale as decimales, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='evento_fechas' ORDER BY ordinal_position332
14SELECT "Texto"."id" AS "Texto__id", "Texto"."texto_es" AS "Texto__texto_es", "Texto"."texto_en" AS "Texto__texto_en", "Texto"."texto_va" AS "Texto__texto_va", "Texto"."texto_de" AS "Texto__texto_de", "Texto"."texto_fr" AS "Texto__texto_fr", "Texto"."texto_pl" AS "Texto__texto_pl", "Texto"."texto_ru" AS "Texto__texto_ru", "Texto"."texto_pt" AS "Texto__texto_pt", "Texto"."texto_nl" AS "Texto__texto_nl", "Texto"."texto_it" AS "Texto__texto_it", "Nodo"."id" AS "Nodo__id", "Nodo"."parent_id" AS "Nodo__parent_id", "Nodo"."tipo" AS "Nodo__tipo", "Nodo"."publicado" AS "Nodo__publicado", "Nodo"."nombre_texto_id" AS "Nodo__nombre_texto_id", "Nodo"."sin_acentos_texto_id" AS "Nodo__sin_acentos_texto_id", "Nodo"."contenido_texto_id" AS "Nodo__contenido_texto_id", "Nodo"."orden" AS "Nodo__orden", "Nodo"."created" AS "Nodo__created", "Nodo"."cabecera_archivo_id" AS "Nodo__cabecera_archivo_id", "Nodo"."subtitulo_texto_id" AS "Nodo__subtitulo_texto_id", "Nodo"."color" AS "Nodo__color", "Nodo"."temporal" AS "Nodo__temporal", "Nodo"."borrable" AS "Nodo__borrable", "Nodo"."movible" AS "Nodo__movible", "Nodo"."editable" AS "Nodo__editable", "Nodo"."mostrar_en_menu" AS "Nodo__mostrar_en_menu", "Nodo"."comentable" AS "Nodo__comentable", "Nodo"."etiqueta_texto_id" AS "Nodo__etiqueta_texto_id", "Nodo"."enviado_boletin" AS "Nodo__enviado_boletin", "Nodo"."title_texto_id" AS "Nodo__title_texto_id", "Nodo"."keywords_texto_id" AS "Nodo__keywords_texto_id", "Nodo"."description_texto_id" AS "Nodo__description_texto_id", "Nodo"."filename_texto_id" AS "Nodo__filename_texto_id", "Nodo"."url_mapa" AS "Nodo__url_mapa", "NodoEtiqueta"."id" AS "NodoEtiqueta__id", "NodoEtiqueta"."parent_id" AS "NodoEtiqueta__parent_id", "NodoEtiqueta"."tipo" AS "NodoEtiqueta__tipo", "NodoEtiqueta"."publicado" AS "NodoEtiqueta__publicado", "NodoEtiqueta"."nombre_texto_id" AS "NodoEtiqueta__nombre_texto_id", "NodoEtiqueta"."sin_acentos_texto_id" AS "NodoEtiqueta__sin_acentos_texto_id", "NodoEtiqueta"."contenido_texto_id" AS "NodoEtiqueta__contenido_texto_id", "NodoEtiqueta"."orden" AS "NodoEtiqueta__orden", "NodoEtiqueta"."created" AS "NodoEtiqueta__created", "NodoEtiqueta"."cabecera_archivo_id" AS "NodoEtiqueta__cabecera_archivo_id", "NodoEtiqueta"."subtitulo_texto_id" AS "NodoEtiqueta__subtitulo_texto_id", "NodoEtiqueta"."color" AS "NodoEtiqueta__color", "NodoEtiqueta"."temporal" AS "NodoEtiqueta__temporal", "NodoEtiqueta"."borrable" AS "NodoEtiqueta__borrable", "NodoEtiqueta"."movible" AS "NodoEtiqueta__movible", "NodoEtiqueta"."editable" AS "NodoEtiqueta__editable", "NodoEtiqueta"."mostrar_en_menu" AS "NodoEtiqueta__mostrar_en_menu", "NodoEtiqueta"."comentable" AS "NodoEtiqueta__comentable", "NodoEtiqueta"."etiqueta_texto_id" AS "NodoEtiqueta__etiqueta_texto_id", "NodoEtiqueta"."enviado_boletin" AS "NodoEtiqueta__enviado_boletin", "NodoEtiqueta"."title_texto_id" AS "NodoEtiqueta__title_texto_id", "NodoEtiqueta"."keywords_texto_id" AS "NodoEtiqueta__keywords_texto_id", "NodoEtiqueta"."description_texto_id" AS "NodoEtiqueta__description_texto_id", "NodoEtiqueta"."filename_texto_id" AS "NodoEtiqueta__filename_texto_id", "NodoEtiqueta"."url_mapa" AS "NodoEtiqueta__url_mapa" FROM "textos" AS "Texto" LEFT JOIN "nodos" AS "Nodo" ON "Nodo"."sin_acentos_texto_id" = "Texto"."id" LEFT JOIN "nodos" AS "NodoEtiqueta" ON "NodoEtiqueta"."etiqueta_texto_id" = "Texto"."id" WHERE texto_es LIKE '%Deportes%' AND "NodoEtiqueta"."publicado"=true AND ( "NodoEtiqueta"."temporal" IS NULL OR "NodoEtiqueta"."temporal"=false) AND "NodoEtiqueta"."tipo"=14 007
15SELECT "Texto"."id" AS "Texto__id", "Texto"."texto_es" AS "Texto__texto_es", "Texto"."texto_en" AS "Texto__texto_en", "Texto"."texto_va" AS "Texto__texto_va", "Texto"."texto_de" AS "Texto__texto_de", "Texto"."texto_fr" AS "Texto__texto_fr", "Texto"."texto_pl" AS "Texto__texto_pl", "Texto"."texto_ru" AS "Texto__texto_ru", "Texto"."texto_pt" AS "Texto__texto_pt", "Texto"."texto_nl" AS "Texto__texto_nl", "Texto"."texto_it" AS "Texto__texto_it", "Nodo"."id" AS "Nodo__id", "Nodo"."parent_id" AS "Nodo__parent_id", "Nodo"."tipo" AS "Nodo__tipo", "Nodo"."publicado" AS "Nodo__publicado", "Nodo"."nombre_texto_id" AS "Nodo__nombre_texto_id", "Nodo"."sin_acentos_texto_id" AS "Nodo__sin_acentos_texto_id", "Nodo"."contenido_texto_id" AS "Nodo__contenido_texto_id", "Nodo"."orden" AS "Nodo__orden", "Nodo"."created" AS "Nodo__created", "Nodo"."cabecera_archivo_id" AS "Nodo__cabecera_archivo_id", "Nodo"."subtitulo_texto_id" AS "Nodo__subtitulo_texto_id", "Nodo"."color" AS "Nodo__color", "Nodo"."temporal" AS "Nodo__temporal", "Nodo"."borrable" AS "Nodo__borrable", "Nodo"."movible" AS "Nodo__movible", "Nodo"."editable" AS "Nodo__editable", "Nodo"."mostrar_en_menu" AS "Nodo__mostrar_en_menu", "Nodo"."comentable" AS "Nodo__comentable", "Nodo"."etiqueta_texto_id" AS "Nodo__etiqueta_texto_id", "Nodo"."enviado_boletin" AS "Nodo__enviado_boletin", "Nodo"."title_texto_id" AS "Nodo__title_texto_id", "Nodo"."keywords_texto_id" AS "Nodo__keywords_texto_id", "Nodo"."description_texto_id" AS "Nodo__description_texto_id", "Nodo"."filename_texto_id" AS "Nodo__filename_texto_id", "Nodo"."url_mapa" AS "Nodo__url_mapa", "NodoEtiqueta"."id" AS "NodoEtiqueta__id", "NodoEtiqueta"."parent_id" AS "NodoEtiqueta__parent_id", "NodoEtiqueta"."tipo" AS "NodoEtiqueta__tipo", "NodoEtiqueta"."publicado" AS "NodoEtiqueta__publicado", "NodoEtiqueta"."nombre_texto_id" AS "NodoEtiqueta__nombre_texto_id", "NodoEtiqueta"."sin_acentos_texto_id" AS "NodoEtiqueta__sin_acentos_texto_id", "NodoEtiqueta"."contenido_texto_id" AS "NodoEtiqueta__contenido_texto_id", "NodoEtiqueta"."orden" AS "NodoEtiqueta__orden", "NodoEtiqueta"."created" AS "NodoEtiqueta__created", "NodoEtiqueta"."cabecera_archivo_id" AS "NodoEtiqueta__cabecera_archivo_id", "NodoEtiqueta"."subtitulo_texto_id" AS "NodoEtiqueta__subtitulo_texto_id", "NodoEtiqueta"."color" AS "NodoEtiqueta__color", "NodoEtiqueta"."temporal" AS "NodoEtiqueta__temporal", "NodoEtiqueta"."borrable" AS "NodoEtiqueta__borrable", "NodoEtiqueta"."movible" AS "NodoEtiqueta__movible", "NodoEtiqueta"."editable" AS "NodoEtiqueta__editable", "NodoEtiqueta"."mostrar_en_menu" AS "NodoEtiqueta__mostrar_en_menu", "NodoEtiqueta"."comentable" AS "NodoEtiqueta__comentable", "NodoEtiqueta"."etiqueta_texto_id" AS "NodoEtiqueta__etiqueta_texto_id", "NodoEtiqueta"."enviado_boletin" AS "NodoEtiqueta__enviado_boletin", "NodoEtiqueta"."title_texto_id" AS "NodoEtiqueta__title_texto_id", "NodoEtiqueta"."keywords_texto_id" AS "NodoEtiqueta__keywords_texto_id", "NodoEtiqueta"."description_texto_id" AS "NodoEtiqueta__description_texto_id", "NodoEtiqueta"."filename_texto_id" AS "NodoEtiqueta__filename_texto_id", "NodoEtiqueta"."url_mapa" AS "NodoEtiqueta__url_mapa" FROM "textos" AS "Texto" LEFT JOIN "nodos" AS "Nodo" ON "Nodo"."sin_acentos_texto_id" = "Texto"."id" LEFT JOIN "nodos" AS "NodoEtiqueta" ON "NodoEtiqueta"."etiqueta_texto_id" = "Texto"."id" WHERE texto_es LIKE '%Deportes%' AND "NodoEtiqueta"."publicado"=true AND ( "NodoEtiqueta"."temporal" IS NULL OR "NodoEtiqueta"."temporal"=false) AND "NodoEtiqueta"."tipo"=12 003
16SELECT "Texto"."id" AS "Texto__id", "Texto"."texto_es" AS "Texto__texto_es", "Texto"."texto_en" AS "Texto__texto_en", "Texto"."texto_va" AS "Texto__texto_va", "Texto"."texto_de" AS "Texto__texto_de", "Texto"."texto_fr" AS "Texto__texto_fr", "Texto"."texto_pl" AS "Texto__texto_pl", "Texto"."texto_ru" AS "Texto__texto_ru", "Texto"."texto_pt" AS "Texto__texto_pt", "Texto"."texto_nl" AS "Texto__texto_nl", "Texto"."texto_it" AS "Texto__texto_it", "Nodo"."id" AS "Nodo__id", "Nodo"."parent_id" AS "Nodo__parent_id", "Nodo"."tipo" AS "Nodo__tipo", "Nodo"."publicado" AS "Nodo__publicado", "Nodo"."nombre_texto_id" AS "Nodo__nombre_texto_id", "Nodo"."sin_acentos_texto_id" AS "Nodo__sin_acentos_texto_id", "Nodo"."contenido_texto_id" AS "Nodo__contenido_texto_id", "Nodo"."orden" AS "Nodo__orden", "Nodo"."created" AS "Nodo__created", "Nodo"."cabecera_archivo_id" AS "Nodo__cabecera_archivo_id", "Nodo"."subtitulo_texto_id" AS "Nodo__subtitulo_texto_id", "Nodo"."color" AS "Nodo__color", "Nodo"."temporal" AS "Nodo__temporal", "Nodo"."borrable" AS "Nodo__borrable", "Nodo"."movible" AS "Nodo__movible", "Nodo"."editable" AS "Nodo__editable", "Nodo"."mostrar_en_menu" AS "Nodo__mostrar_en_menu", "Nodo"."comentable" AS "Nodo__comentable", "Nodo"."etiqueta_texto_id" AS "Nodo__etiqueta_texto_id", "Nodo"."enviado_boletin" AS "Nodo__enviado_boletin", "Nodo"."title_texto_id" AS "Nodo__title_texto_id", "Nodo"."keywords_texto_id" AS "Nodo__keywords_texto_id", "Nodo"."description_texto_id" AS "Nodo__description_texto_id", "Nodo"."filename_texto_id" AS "Nodo__filename_texto_id", "Nodo"."url_mapa" AS "Nodo__url_mapa", "NodoEtiqueta"."id" AS "NodoEtiqueta__id", "NodoEtiqueta"."parent_id" AS "NodoEtiqueta__parent_id", "NodoEtiqueta"."tipo" AS "NodoEtiqueta__tipo", "NodoEtiqueta"."publicado" AS "NodoEtiqueta__publicado", "NodoEtiqueta"."nombre_texto_id" AS "NodoEtiqueta__nombre_texto_id", "NodoEtiqueta"."sin_acentos_texto_id" AS "NodoEtiqueta__sin_acentos_texto_id", "NodoEtiqueta"."contenido_texto_id" AS "NodoEtiqueta__contenido_texto_id", "NodoEtiqueta"."orden" AS "NodoEtiqueta__orden", "NodoEtiqueta"."created" AS "NodoEtiqueta__created", "NodoEtiqueta"."cabecera_archivo_id" AS "NodoEtiqueta__cabecera_archivo_id", "NodoEtiqueta"."subtitulo_texto_id" AS "NodoEtiqueta__subtitulo_texto_id", "NodoEtiqueta"."color" AS "NodoEtiqueta__color", "NodoEtiqueta"."temporal" AS "NodoEtiqueta__temporal", "NodoEtiqueta"."borrable" AS "NodoEtiqueta__borrable", "NodoEtiqueta"."movible" AS "NodoEtiqueta__movible", "NodoEtiqueta"."editable" AS "NodoEtiqueta__editable", "NodoEtiqueta"."mostrar_en_menu" AS "NodoEtiqueta__mostrar_en_menu", "NodoEtiqueta"."comentable" AS "NodoEtiqueta__comentable", "NodoEtiqueta"."etiqueta_texto_id" AS "NodoEtiqueta__etiqueta_texto_id", "NodoEtiqueta"."enviado_boletin" AS "NodoEtiqueta__enviado_boletin", "NodoEtiqueta"."title_texto_id" AS "NodoEtiqueta__title_texto_id", "NodoEtiqueta"."keywords_texto_id" AS "NodoEtiqueta__keywords_texto_id", "NodoEtiqueta"."description_texto_id" AS "NodoEtiqueta__description_texto_id", "NodoEtiqueta"."filename_texto_id" AS "NodoEtiqueta__filename_texto_id", "NodoEtiqueta"."url_mapa" AS "NodoEtiqueta__url_mapa" FROM "textos" AS "Texto" LEFT JOIN "nodos" AS "Nodo" ON "Nodo"."sin_acentos_texto_id" = "Texto"."id" LEFT JOIN "nodos" AS "NodoEtiqueta" ON "NodoEtiqueta"."etiqueta_texto_id" = "Texto"."id" WHERE texto_es LIKE '%Deportes%' AND "NodoEtiqueta"."publicado"=true AND ( "NodoEtiqueta"."temporal" IS NULL OR "NodoEtiqueta"."temporal"=false) AND "NodoEtiqueta"."tipo"=6 0075
17SELECT "Texto"."id" AS "Texto__id", "Texto"."texto_es" AS "Texto__texto_es", "Texto"."texto_en" AS "Texto__texto_en", "Texto"."texto_va" AS "Texto__texto_va", "Texto"."texto_de" AS "Texto__texto_de", "Texto"."texto_fr" AS "Texto__texto_fr", "Texto"."texto_pl" AS "Texto__texto_pl", "Texto"."texto_ru" AS "Texto__texto_ru", "Texto"."texto_pt" AS "Texto__texto_pt", "Texto"."texto_nl" AS "Texto__texto_nl", "Texto"."texto_it" AS "Texto__texto_it", "Nodo"."id" AS "Nodo__id", "Nodo"."parent_id" AS "Nodo__parent_id", "Nodo"."tipo" AS "Nodo__tipo", "Nodo"."publicado" AS "Nodo__publicado", "Nodo"."nombre_texto_id" AS "Nodo__nombre_texto_id", "Nodo"."sin_acentos_texto_id" AS "Nodo__sin_acentos_texto_id", "Nodo"."contenido_texto_id" AS "Nodo__contenido_texto_id", "Nodo"."orden" AS "Nodo__orden", "Nodo"."created" AS "Nodo__created", "Nodo"."cabecera_archivo_id" AS "Nodo__cabecera_archivo_id", "Nodo"."subtitulo_texto_id" AS "Nodo__subtitulo_texto_id", "Nodo"."color" AS "Nodo__color", "Nodo"."temporal" AS "Nodo__temporal", "Nodo"."borrable" AS "Nodo__borrable", "Nodo"."movible" AS "Nodo__movible", "Nodo"."editable" AS "Nodo__editable", "Nodo"."mostrar_en_menu" AS "Nodo__mostrar_en_menu", "Nodo"."comentable" AS "Nodo__comentable", "Nodo"."etiqueta_texto_id" AS "Nodo__etiqueta_texto_id", "Nodo"."enviado_boletin" AS "Nodo__enviado_boletin", "Nodo"."title_texto_id" AS "Nodo__title_texto_id", "Nodo"."keywords_texto_id" AS "Nodo__keywords_texto_id", "Nodo"."description_texto_id" AS "Nodo__description_texto_id", "Nodo"."filename_texto_id" AS "Nodo__filename_texto_id", "Nodo"."url_mapa" AS "Nodo__url_mapa", "NodoEtiqueta"."id" AS "NodoEtiqueta__id", "NodoEtiqueta"."parent_id" AS "NodoEtiqueta__parent_id", "NodoEtiqueta"."tipo" AS "NodoEtiqueta__tipo", "NodoEtiqueta"."publicado" AS "NodoEtiqueta__publicado", "NodoEtiqueta"."nombre_texto_id" AS "NodoEtiqueta__nombre_texto_id", "NodoEtiqueta"."sin_acentos_texto_id" AS "NodoEtiqueta__sin_acentos_texto_id", "NodoEtiqueta"."contenido_texto_id" AS "NodoEtiqueta__contenido_texto_id", "NodoEtiqueta"."orden" AS "NodoEtiqueta__orden", "NodoEtiqueta"."created" AS "NodoEtiqueta__created", "NodoEtiqueta"."cabecera_archivo_id" AS "NodoEtiqueta__cabecera_archivo_id", "NodoEtiqueta"."subtitulo_texto_id" AS "NodoEtiqueta__subtitulo_texto_id", "NodoEtiqueta"."color" AS "NodoEtiqueta__color", "NodoEtiqueta"."temporal" AS "NodoEtiqueta__temporal", "NodoEtiqueta"."borrable" AS "NodoEtiqueta__borrable", "NodoEtiqueta"."movible" AS "NodoEtiqueta__movible", "NodoEtiqueta"."editable" AS "NodoEtiqueta__editable", "NodoEtiqueta"."mostrar_en_menu" AS "NodoEtiqueta__mostrar_en_menu", "NodoEtiqueta"."comentable" AS "NodoEtiqueta__comentable", "NodoEtiqueta"."etiqueta_texto_id" AS "NodoEtiqueta__etiqueta_texto_id", "NodoEtiqueta"."enviado_boletin" AS "NodoEtiqueta__enviado_boletin", "NodoEtiqueta"."title_texto_id" AS "NodoEtiqueta__title_texto_id", "NodoEtiqueta"."keywords_texto_id" AS "NodoEtiqueta__keywords_texto_id", "NodoEtiqueta"."description_texto_id" AS "NodoEtiqueta__description_texto_id", "NodoEtiqueta"."filename_texto_id" AS "NodoEtiqueta__filename_texto_id", "NodoEtiqueta"."url_mapa" AS "NodoEtiqueta__url_mapa" FROM "textos" AS "Texto" LEFT JOIN "nodos" AS "Nodo" ON "Nodo"."sin_acentos_texto_id" = "Texto"."id" LEFT JOIN "nodos" AS "NodoEtiqueta" ON "NodoEtiqueta"."etiqueta_texto_id" = "Texto"."id" WHERE texto_es LIKE '%Deportes%' AND "NodoEtiqueta"."publicado"=true AND ( "NodoEtiqueta"."temporal" IS NULL OR "NodoEtiqueta"."temporal"=false) AND "NodoEtiqueta"."tipo"=2 004
18SELECT "Etiqueta"."id" AS "Etiqueta__id", "Etiqueta"."nombre" AS "Etiqueta__nombre", "Etiqueta"."idioma" AS "Etiqueta__idioma", "Etiqueta"."numero" AS "Etiqueta__numero", "Etiqueta"."icono_archivo_id" AS "Etiqueta__icono_archivo_id", "Etiqueta"."descripcion" AS "Etiqueta__descripcion", "Etiqueta"."cabecera_archivo_id" AS "Etiqueta__cabecera_archivo_id", "Icono"."id" AS "Icono__id", "Icono"."nodo_id" AS "Icono__nodo_id", "Icono"."extension" AS "Icono__extension", "Icono"."nombre" AS "Icono__nombre", "Icono"."idioma" AS "Icono__idioma", "Icono"."orden" AS "Icono__orden", "Icono"."mostrar" AS "Icono__mostrar", "Icono"."created" AS "Icono__created", "Icono"."categoria" AS "Icono__categoria", "Icono"."privado" AS "Icono__privado", "Icono"."bytes" AS "Icono__bytes", "Icono"."tipo" AS "Icono__tipo", "Cabecera"."id" AS "Cabecera__id", "Cabecera"."nodo_id" AS "Cabecera__nodo_id", "Cabecera"."extension" AS "Cabecera__extension", "Cabecera"."nombre" AS "Cabecera__nombre", "Cabecera"."idioma" AS "Cabecera__idioma", "Cabecera"."orden" AS "Cabecera__orden", "Cabecera"."mostrar" AS "Cabecera__mostrar", "Cabecera"."created" AS "Cabecera__created", "Cabecera"."categoria" AS "Cabecera__categoria", "Cabecera"."privado" AS "Cabecera__privado", "Cabecera"."bytes" AS "Cabecera__bytes", "Cabecera"."tipo" AS "Cabecera__tipo" FROM "etiquetas" AS "Etiqueta" LEFT JOIN "archivos" AS "Icono" ON "Etiqueta"."icono_archivo_id" = "Icono"."id" LEFT JOIN "archivos" AS "Cabecera" ON "Etiqueta"."cabecera_archivo_id" = "Cabecera"."id" WHERE "Etiqueta"."idioma"='es' 551
19SELECT "Etiqueta"."id" AS "Etiqueta__id", "Etiqueta"."nombre" AS "Etiqueta__nombre", "Etiqueta"."idioma" AS "Etiqueta__idioma", "Etiqueta"."numero" AS "Etiqueta__numero", "Etiqueta"."icono_archivo_id" AS "Etiqueta__icono_archivo_id", "Etiqueta"."descripcion" AS "Etiqueta__descripcion", "Etiqueta"."cabecera_archivo_id" AS "Etiqueta__cabecera_archivo_id", "Icono"."id" AS "Icono__id", "Icono"."nodo_id" AS "Icono__nodo_id", "Icono"."extension" AS "Icono__extension", "Icono"."nombre" AS "Icono__nombre", "Icono"."idioma" AS "Icono__idioma", "Icono"."orden" AS "Icono__orden", "Icono"."mostrar" AS "Icono__mostrar", "Icono"."created" AS "Icono__created", "Icono"."categoria" AS "Icono__categoria", "Icono"."privado" AS "Icono__privado", "Icono"."bytes" AS "Icono__bytes", "Icono"."tipo" AS "Icono__tipo", "Cabecera"."id" AS "Cabecera__id", "Cabecera"."nodo_id" AS "Cabecera__nodo_id", "Cabecera"."extension" AS "Cabecera__extension", "Cabecera"."nombre" AS "Cabecera__nombre", "Cabecera"."idioma" AS "Cabecera__idioma", "Cabecera"."orden" AS "Cabecera__orden", "Cabecera"."mostrar" AS "Cabecera__mostrar", "Cabecera"."created" AS "Cabecera__created", "Cabecera"."categoria" AS "Cabecera__categoria", "Cabecera"."privado" AS "Cabecera__privado", "Cabecera"."bytes" AS "Cabecera__bytes", "Cabecera"."tipo" AS "Cabecera__tipo" FROM "etiquetas" AS "Etiqueta" LEFT JOIN "archivos" AS "Icono" ON "Etiqueta"."icono_archivo_id" = "Icono"."id" LEFT JOIN "archivos" AS "Cabecera" ON "Etiqueta"."cabecera_archivo_id" = "Cabecera"."id" WHERE "Etiqueta"."idioma"='es' AND "Etiqueta"."nombre"='Deportes' LIMIT 1110
20SELECT "Nodo"."id" AS "Nodo__id", "Nodo"."parent_id" AS "Nodo__parent_id", "Nodo"."tipo" AS "Nodo__tipo", "Nodo"."publicado" AS "Nodo__publicado", "Nodo"."nombre_texto_id" AS "Nodo__nombre_texto_id", "Nodo"."sin_acentos_texto_id" AS "Nodo__sin_acentos_texto_id", "Nodo"."contenido_texto_id" AS "Nodo__contenido_texto_id", "Nodo"."orden" AS "Nodo__orden", "Nodo"."created" AS "Nodo__created", "Nodo"."cabecera_archivo_id" AS "Nodo__cabecera_archivo_id", "Nodo"."subtitulo_texto_id" AS "Nodo__subtitulo_texto_id", "Nodo"."color" AS "Nodo__color", "Nodo"."temporal" AS "Nodo__temporal", "Nodo"."borrable" AS "Nodo__borrable", "Nodo"."movible" AS "Nodo__movible", "Nodo"."editable" AS "Nodo__editable", "Nodo"."mostrar_en_menu" AS "Nodo__mostrar_en_menu", "Nodo"."comentable" AS "Nodo__comentable", "Nodo"."etiqueta_texto_id" AS "Nodo__etiqueta_texto_id", "Nodo"."enviado_boletin" AS "Nodo__enviado_boletin", "Nodo"."title_texto_id" AS "Nodo__title_texto_id", "Nodo"."keywords_texto_id" AS "Nodo__keywords_texto_id", "Nodo"."description_texto_id" AS "Nodo__description_texto_id", "Nodo"."filename_texto_id" AS "Nodo__filename_texto_id", "Nodo"."url_mapa" AS "Nodo__url_mapa", "Nombre"."id" AS "Nombre__id", "Nombre"."texto_es" AS "Nombre__texto_es", "Nombre"."texto_en" AS "Nombre__texto_en", "Nombre"."texto_va" AS "Nombre__texto_va", "Nombre"."texto_de" AS "Nombre__texto_de", "Nombre"."texto_fr" AS "Nombre__texto_fr", "Nombre"."texto_pl" AS "Nombre__texto_pl", "Nombre"."texto_ru" AS "Nombre__texto_ru", "Nombre"."texto_pt" AS "Nombre__texto_pt", "Nombre"."texto_nl" AS "Nombre__texto_nl", "Nombre"."texto_it" AS "Nombre__texto_it", "Title"."id" AS "Title__id", "Title"."texto_es" AS "Title__texto_es", "Title"."texto_en" AS "Title__texto_en", "Title"."texto_va" AS "Title__texto_va", "Title"."texto_de" AS "Title__texto_de", "Title"."texto_fr" AS "Title__texto_fr", "Title"."texto_pl" AS "Title__texto_pl", "Title"."texto_ru" AS "Title__texto_ru", "Title"."texto_pt" AS "Title__texto_pt", "Title"."texto_nl" AS "Title__texto_nl", "Title"."texto_it" AS "Title__texto_it", "Filename"."id" AS "Filename__id", "Filename"."texto_es" AS "Filename__texto_es", "Filename"."texto_en" AS "Filename__texto_en", "Filename"."texto_va" AS "Filename__texto_va", "Filename"."texto_de" AS "Filename__texto_de", "Filename"."texto_fr" AS "Filename__texto_fr", "Filename"."texto_pl" AS "Filename__texto_pl", "Filename"."texto_ru" AS "Filename__texto_ru", "Filename"."texto_pt" AS "Filename__texto_pt", "Filename"."texto_nl" AS "Filename__texto_nl", "Filename"."texto_it" AS "Filename__texto_it" FROM "nodos" AS "Nodo" LEFT JOIN "textos" AS "Nombre" ON "Nodo"."nombre_texto_id" = "Nombre"."id" LEFT JOIN "textos" AS "Title" ON "Nodo"."title_texto_id" = "Title"."id" LEFT JOIN "textos" AS "Filename" ON "Nodo"."filename_texto_id" = "Filename"."id" WHERE ( "Nodo"."tipo" IN( 0,1,2,3,5,7,9,11,12,13,14,15,16,17,18,19,20,21,24,25,26,28,29,30,32,33,34,36,40,44,45 ) AND "Nodo"."mostrar_en_menu"=TRUE) AND (( "Nodo"."temporal" IS NULL OR "Nodo"."temporal"=false) AND "Nodo"."publicado"=true) ORDER BY "Nodo"."orden" ASC, "Nodo"."id" ASC 2782787
21SELECT "Etiqueta"."id" AS "Etiqueta__id", "Etiqueta"."nombre" AS "Etiqueta__nombre", "Etiqueta"."idioma" AS "Etiqueta__idioma", "Etiqueta"."numero" AS "Etiqueta__numero", "Etiqueta"."icono_archivo_id" AS "Etiqueta__icono_archivo_id", "Etiqueta"."descripcion" AS "Etiqueta__descripcion", "Etiqueta"."cabecera_archivo_id" AS "Etiqueta__cabecera_archivo_id", "Icono"."id" AS "Icono__id", "Icono"."nodo_id" AS "Icono__nodo_id", "Icono"."extension" AS "Icono__extension", "Icono"."nombre" AS "Icono__nombre", "Icono"."idioma" AS "Icono__idioma", "Icono"."orden" AS "Icono__orden", "Icono"."mostrar" AS "Icono__mostrar", "Icono"."created" AS "Icono__created", "Icono"."categoria" AS "Icono__categoria", "Icono"."privado" AS "Icono__privado", "Icono"."bytes" AS "Icono__bytes", "Icono"."tipo" AS "Icono__tipo", "Cabecera"."id" AS "Cabecera__id", "Cabecera"."nodo_id" AS "Cabecera__nodo_id", "Cabecera"."extension" AS "Cabecera__extension", "Cabecera"."nombre" AS "Cabecera__nombre", "Cabecera"."idioma" AS "Cabecera__idioma", "Cabecera"."orden" AS "Cabecera__orden", "Cabecera"."mostrar" AS "Cabecera__mostrar", "Cabecera"."created" AS "Cabecera__created", "Cabecera"."categoria" AS "Cabecera__categoria", "Cabecera"."privado" AS "Cabecera__privado", "Cabecera"."bytes" AS "Cabecera__bytes", "Cabecera"."tipo" AS "Cabecera__tipo" FROM "etiquetas" AS "Etiqueta" LEFT JOIN "archivos" AS "Icono" ON "Etiqueta"."icono_archivo_id" = "Icono"."id" LEFT JOIN "archivos" AS "Cabecera" ON "Etiqueta"."cabecera_archivo_id" = "Cabecera"."id" WHERE "Etiqueta"."idioma"='es' ORDER BY "Etiqueta"."numero" DESC, "Etiqueta"."nombre" ASC 550